
drop view dbo.view_students_progess
go

create view dbo.view_students_progess
as 
   select last_name,
          first_name,
		[goal]
      ,[target]
      ,[student_id]
      ,b.[id] s_g_id 
      ,[goal_id]
      ,[progress]
      ,[record_date]
 
     from students a left outer join view_students_goals b on a.id = b.student_id
     
     /*
     select * from students
     
     select * from view_students_progess
     
     */